package org.jeecg.modules.ParameterModule.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.ParameterModule.entity.*;

import java.util.List;

/**
 * 导入导出Mapper类
 * */
public interface ImportExportMapper extends BaseMapper<ExcelCategoryInfo> {
    /**
     * 导出定制项下的参数
     */
    List<ExcelCategoryInfo> ExportCategory(@Param("category_id")String category_id);
    /**
     * 导出绣字工艺-绣字部位
     */
    List<ExcelXiuziLocaltion> Exportxiuzi_localtion(@Param("category_id")String category_id);
    /**
     * 导出绣字工艺-绣字颜色
     */
    List<ExcelXiuziColor> Exportxiuzi_color(@Param("category_id")String category_id);
    /**
     * 导出绣字工艺-绣字图片
     */
    List<ExcelXiuziFontImg2> Exportxiuzi_img(@Param("category_id")String category_id);
    /**
     * 导出绣字工艺-绣字字体
     */
    List<ExcelXiuziFontImg> Exportxiuzi_font(@Param("category_id")String category_id);
    /**
     * 导出绣字工艺-绣字高度
     */
    List<ExcelXiuziHeight> Exportxiuzi_height(@Param("category_id")String category_id);
    /**
     * 导出尺寸
     * @param type   0成衣尺寸，1净体尺寸
     * @param category_id 类别id
     */
    List<ExcelBodysizes> Export_bodysizes(@Param("category_id")String category_id,@Param("type")int type);
    /**
     * 导出返修尺寸
     * @param category_id 面料册ID
     */
    List<ExcelFanxiuBodysize> Export_fanxiu_bodysizes(@Param("category_id")String category_id);
    /**
     * 导出工艺类型
     * @param category_id 面料册ID
     */
    List<ExcelCategoryGongyi> Export_all_gongyi(@Param("category_id")String category_id);
    /**
     * 导出撞色项
     * @param category_id 类别idID
     */
    List<ExcelZhuangseInfo> Export_category_zhuangse(@Param("category_id")String category_id);

    /**
     * 根据品类id和定制项name查询定制项
     */
    ExcelCategoryInfo query_dingzhiDetailBynameId(@Param("category_id")String category_id,@Param("name")String name);
    //根据品类id和定制项id和参数名称查询参数
    ExcelCategoryInfo query_canshuDetailBynameId(@Param("category_id")String category_id,@Param("dingzhi_id")String dingzhi_id,@Param("name")String name);

    /**
     * 根据类别id删除定制项
     */
    int real_delete_dingzhi(@Param("category_id")String category_id);
    /**
     * 根据类别id删除定制项下面的参数
     */
    int real_delete_dingzhi_canshu(@Param("category_id")String category_id);
    /**
     * 根据类别id和定制项id删除撞色
     */
    int real_delete_contrastcolor(@Param("category_id")String category_id, @Param("dingzhi_id")String dingzhi_id);
    /**
     * 根据类别id和定制项id删除互斥
     */
    int real_delete_MutexTestInfo(@Param("category_id")String category_id, @Param("dingzhi_id")String dingzhi_id);

    //根据品类id和编码查询绣字位置
    ExcelXiuziLocaltion query_xiuziLocaltionDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);
    //根据品类id和编码查询绣字颜色
    ExcelXiuziColor query_xiuzicolorDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);
    //根据品类id和编码查询绣字图片
    ExcelXiuziFontImg2 query_xiuziImgDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);
    //根据品类id和编码查询绣字字体
    ExcelXiuziFontImg query_xiuzifontDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);
    //根据品类id和编码查询绣字高度
    ExcelXiuziHeight query_xiuziheightDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);

    //根据品类id和名称查询尺寸-0成衣，1净体
    ExcelBodysizes query_bodysizeDetailBynameId(@Param("category_id")String category_id,@Param("name")String name,@Param("type")int type);
    //根据品类id和名称查询返修尺寸
    ExcelFanxiuBodysize query_fanxiubodysizeDetailBynameId(@Param("category_id")String category_id,@Param("name")String name);
    //根据品类id和编码查询工艺类型
    ExcelCategoryGongyi query_gongyiDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);
    //根据品类id和编码查询撞色
    ExcelZhuangseInfo query_zhuangseDetailBycodeId(@Param("category_id")String category_id,@Param("code")String code);


    /**根据名称查询区域*/
    //根据品类id和名称查询尺寸-0成衣，1净体
    ExcelBodysizes query_bodysizeDetailByname(@Param("category_id")String category_id,@Param("data_name")String data_name,@Param("type")int type);
    //根据品类id和名称查询返修尺寸
    ExcelFanxiuBodysize query_fanxiubodysizeDetailByname(@Param("category_id")String category_id,@Param("data_name")String data_name);
    //根据品类id和名称查询工艺类型
    ExcelCategoryGongyi query_gongyiDetailByname(@Param("category_id")String category_id,@Param("data_name")String data_name);
    //根据品类id和定制项id和参数名称查询参数
    ExcelCategoryInfo query_canshuDetailByname(@Param("category_id")String category_id,@Param("dingzhi_id")String dingzhi_id,@Param("data_name")String data_name);

}
